Dataset statistics
| Number of variables | 18 |
|---|---|
| Number of observations | 12695 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 867 |
| Duplicate rows (%) | 6.8% |
| Total size in memory | 2.3 MiB |
| Average record size in memory | 193.6 B |
Variable types
| Categorical | 8 |
|---|---|
| Numeric | 10 |
| Dataset has 867 (6.8%) duplicate rows | Duplicates |
no_of_previous_bookings_not_canceled is highly overall correlated with repeated_guest | High correlation |
repeated_guest is highly overall correlated with no_of_previous_bookings_not_canceled | High correlation |
no_of_adults is highly imbalanced (52.8%) | Imbalance |
no_of_children is highly imbalanced (76.7%) | Imbalance |
type_of_meal_plan is highly imbalanced (50.2%) | Imbalance |
required_car_parking_space is highly imbalanced (79.2%) | Imbalance |
repeated_guest is highly imbalanced (83.0%) | Imbalance |
no_of_previous_cancellations is highly skewed (γ1 = 25.12430521) | Skewed |
no_of_weekend_nights has 5903 (46.5%) zeros | Zeros |
no_of_week_nights has 849 (6.7%) zeros | Zeros |
room_type_reserved has 9833 (77.5%) zeros | Zeros |
lead_time has 463 (3.6%) zeros | Zeros |
no_of_previous_cancellations has 12587 (99.1%) zeros | Zeros |
no_of_previous_bookings_not_canceled has 12409 (97.7%) zeros | Zeros |
avg_price_per_room has 193 (1.5%) zeros | Zeros |
no_of_special_requests has 6897 (54.3%) zeros | Zeros |
Reproduction
| Analysis started | 2023-03-13 03:07:20.295971 |
|---|---|
| Analysis finished | 2023-03-13 03:07:28.766965 |
| Duration | 8.47 seconds |
| Software version | pandas-profiling v0.0.dev0 |
| Download configuration | config.json |
no_of_adults
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 714.4 KiB |
| 2 | |
|---|---|
| 1 | |
| 3 | 822 |
| 0 | 47 |
| 4 | 4 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 12695 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 2 |
| 3rd row | 2 |
| 4th row | 2 |
| 5th row | 2 |
Common Values
| Value | Count | Frequency (%) |
| 2 | 9199 | |
| 1 | 2623 | 20.7% |
| 3 | 822 | 6.5% |
| 0 | 47 | 0.4% |
| 4 | 4 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2 | 9199 | |
| 1 | 2623 | 20.7% |
| 3 | 822 | 6.5% |
| 0 | 47 | 0.4% |
| 4 | 4 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 9199 | |
| 1 | 2623 | 20.7% |
| 3 | 822 | 6.5% |
| 0 | 47 | 0.4% |
| 4 | 4 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 12695 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 9199 | |
| 1 | 2623 | 20.7% |
| 3 | 822 | 6.5% |
| 0 | 47 | 0.4% |
| 4 | 4 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 12695 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 9199 | |
| 1 | 2623 | 20.7% |
| 3 | 822 | 6.5% |
| 0 | 47 | 0.4% |
| 4 | 4 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 12695 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 9199 | |
| 1 | 2623 | 20.7% |
| 3 | 822 | 6.5% |
| 0 | 47 | 0.4% |
| 4 | 4 | < 0.1% |
no_of_children
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 714.4 KiB |
| 0 | |
|---|---|
| 1 | 575 |
| 2 | 379 |
| 3 | 8 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 12695 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 11733 | |
| 1 | 575 | 4.5% |
| 2 | 379 | 3.0% |
| 3 | 8 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 11733 | |
| 1 | 575 | 4.5% |
| 2 | 379 | 3.0% |
| 3 | 8 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 11733 | |
| 1 | 575 | 4.5% |
| 2 | 379 | 3.0% |
| 3 | 8 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 12695 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 11733 | |
| 1 | 575 | 4.5% |
| 2 | 379 | 3.0% |
| 3 | 8 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 12695 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 11733 | |
| 1 | 575 | 4.5% |
| 2 | 379 | 3.0% |
| 3 | 8 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 12695 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 11733 | |
| 1 | 575 | 4.5% |
| 2 | 379 | 3.0% |
| 3 | 8 | 0.1% |
no_of_weekend_nights
Real number (ℝ)
| Distinct | 8 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.80913746 |
| Minimum | 0 |
|---|---|
| Maximum | 7 |
| Zeros | 5903 |
| Zeros (%) | 46.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 714.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 7 |
| Range | 7 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 0.87011098 |
|---|---|
| Coefficient of variation (CV) | 1.0753562 |
| Kurtosis | 0.50021729 |
| Mean | 0.80913746 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.76285186 |
| Sum | 10272 |
| Variance | 0.75709312 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=8)
| Value | Count | Frequency (%) |
| 0 | 5903 | |
| 1 | 3523 | |
| 2 | 3148 | |
| 3 | 64 | 0.5% |
| 4 | 34 | 0.3% |
| 5 | 14 | 0.1% |
| 6 | 8 | 0.1% |
| 7 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 5903 | |
| 1 | 3523 | |
| 2 | 3148 | |
| 3 | 64 | 0.5% |
| 4 | 34 | 0.3% |
| 5 | 14 | 0.1% |
| 6 | 8 | 0.1% |
| 7 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 7 | 1 | < 0.1% |
| 6 | 8 | 0.1% |
| 5 | 14 | 0.1% |
| 4 | 34 | 0.3% |
| 3 | 64 | 0.5% |
| 2 | 3148 | |
| 1 | 3523 | |
| 0 | 5903 |
no_of_week_nights
Real number (ℝ)
| Distinct | 18 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.2029145 |
| Minimum | 0 |
|---|---|
| Maximum | 17 |
| Zeros | 849 |
| Zeros (%) | 6.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 714.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 2 |
| Q3 | 3 |
| 95-th percentile | 5 |
| Maximum | 17 |
| Range | 17 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.4198644 |
|---|---|
| Coefficient of variation (CV) | 0.64453902 |
| Kurtosis | 9.3228691 |
| Mean | 2.2029145 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.735608 |
| Sum | 27966 |
| Variance | 2.0160148 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=18)
| Value | Count | Frequency (%) |
| 2 | 4026 | |
| 1 | 3294 | |
| 3 | 2748 | |
| 4 | 1049 | 8.3% |
| 0 | 849 | 6.7% |
| 5 | 550 | 4.3% |
| 6 | 67 | 0.5% |
| 7 | 38 | 0.3% |
| 10 | 22 | 0.2% |
| 8 | 18 | 0.1% |
| Other values (8) | 34 | 0.3% |
| Value | Count | Frequency (%) |
| 0 | 849 | 6.7% |
| 1 | 3294 | |
| 2 | 4026 | |
| 3 | 2748 | |
| 4 | 1049 | 8.3% |
| 5 | 550 | 4.3% |
| 6 | 67 | 0.5% |
| 7 | 38 | 0.3% |
| 8 | 18 | 0.1% |
| 9 | 14 | 0.1% |
| Value | Count | Frequency (%) |
| 17 | 2 | < 0.1% |
| 16 | 1 | < 0.1% |
| 15 | 5 | < 0.1% |
| 14 | 2 | < 0.1% |
| 13 | 3 | < 0.1% |
| 12 | 3 | < 0.1% |
| 11 | 4 | < 0.1% |
| 10 | 22 | |
| 9 | 14 | |
| 8 | 18 |
type_of_meal_plan
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 714.4 KiB |
| 0 | |
|---|---|
| 1 | |
| 2 | |
| 3 | 3 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 12695 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 9810 | |
| 1 | 1745 | 13.7% |
| 2 | 1137 | 9.0% |
| 3 | 3 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 9810 | |
| 1 | 1745 | 13.7% |
| 2 | 1137 | 9.0% |
| 3 | 3 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 9810 | |
| 1 | 1745 | 13.7% |
| 2 | 1137 | 9.0% |
| 3 | 3 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 12695 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 9810 | |
| 1 | 1745 | 13.7% |
| 2 | 1137 | 9.0% |
| 3 | 3 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 12695 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 9810 | |
| 1 | 1745 | 13.7% |
| 2 | 1137 | 9.0% |
| 3 | 3 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 12695 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 9810 | |
| 1 | 1745 | 13.7% |
| 2 | 1137 | 9.0% |
| 3 | 3 | < 0.1% |
required_car_parking_space
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 714.4 KiB |
| 0 | |
|---|---|
| 1 | 415 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 12695 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 12280 | |
| 1 | 415 | 3.3% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 12280 | |
| 1 | 415 | 3.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 12280 | |
| 1 | 415 | 3.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 12695 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 12280 | |
| 1 | 415 | 3.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 12695 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 12280 | |
| 1 | 415 | 3.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 12695 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 12280 | |
| 1 | 415 | 3.3% |
room_type_reserved
Real number (ℝ)
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.33800709 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 9833 |
| Zeros (%) | 77.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 714.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 2 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.77501412 |
|---|---|
| Coefficient of variation (CV) | 2.2928931 |
| Kurtosis | 11.016307 |
| Mean | 0.33800709 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.0809864 |
| Sum | 4291 |
| Variance | 0.60064689 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 0 | 9833 | |
| 1 | 2129 | 16.8% |
| 3 | 351 | 2.8% |
| 2 | 240 | 1.9% |
| 4 | 84 | 0.7% |
| 5 | 55 | 0.4% |
| 6 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 9833 | |
| 1 | 2129 | 16.8% |
| 2 | 240 | 1.9% |
| 3 | 351 | 2.8% |
| 4 | 84 | 0.7% |
| 5 | 55 | 0.4% |
| 6 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 6 | 3 | < 0.1% |
| 5 | 55 | 0.4% |
| 4 | 84 | 0.7% |
| 3 | 351 | 2.8% |
| 2 | 240 | 1.9% |
| 1 | 2129 | 16.8% |
| 0 | 9833 |
lead_time
Real number (ℝ)
| Distinct | 340 |
|---|---|
| Distinct (%) | 2.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 85.579913 |
| Minimum | 0 |
|---|---|
| Maximum | 443 |
| Zeros | 463 |
| Zeros (%) | 3.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 714.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 16 |
| median | 57 |
| Q3 | 127 |
| 95-th percentile | 275 |
| Maximum | 443 |
| Range | 443 |
| Interquartile range (IQR) | 111 |
Descriptive statistics
| Standard deviation | 87.294409 |
|---|---|
| Coefficient of variation (CV) | 1.0200339 |
| Kurtosis | 1.1575297 |
| Mean | 85.579913 |
| Median Absolute Deviation (MAD) | 47 |
| Skewness | 1.3011756 |
| Sum | 1086437 |
| Variance | 7620.3139 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 463 | 3.6% |
| 1 | 374 | 2.9% |
| 2 | 234 | 1.8% |
| 4 | 234 | 1.8% |
| 3 | 220 | 1.7% |
| 5 | 191 | 1.5% |
| 6 | 188 | 1.5% |
| 8 | 166 | 1.3% |
| 7 | 154 | 1.2% |
| 12 | 143 | 1.1% |
| Other values (330) | 10328 |
| Value | Count | Frequency (%) |
| 0 | 463 | |
| 1 | 374 | |
| 2 | 234 | |
| 3 | 220 | |
| 4 | 234 | |
| 5 | 191 | |
| 6 | 188 | |
| 7 | 154 | 1.2% |
| 8 | 166 | 1.3% |
| 9 | 122 | 1.0% |
| Value | Count | Frequency (%) |
| 443 | 9 | 0.1% |
| 433 | 8 | 0.1% |
| 418 | 23 | |
| 386 | 23 | |
| 381 | 1 | < 0.1% |
| 377 | 29 | |
| 361 | 1 | < 0.1% |
| 359 | 7 | 0.1% |
| 353 | 1 | < 0.1% |
| 352 | 1 | < 0.1% |
arrival_year
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 714.4 KiB |
| 2018 | |
|---|---|
| 2017 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 50780 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2018 |
|---|---|
| 2nd row | 2018 |
| 3rd row | 2017 |
| 4th row | 2018 |
| 5th row | 2018 |
Common Values
| Value | Count | Frequency (%) |
| 2018 | 10415 | |
| 2017 | 2280 | 18.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2018 | 10415 | |
| 2017 | 2280 | 18.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 12695 | |
| 0 | 12695 | |
| 1 | 12695 | |
| 8 | 10415 | |
| 7 | 2280 | 4.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 50780 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 12695 | |
| 0 | 12695 | |
| 1 | 12695 | |
| 8 | 10415 | |
| 7 | 2280 | 4.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 50780 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 12695 | |
| 0 | 12695 | |
| 1 | 12695 | |
| 8 | 10415 | |
| 7 | 2280 | 4.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 50780 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 12695 | |
| 0 | 12695 | |
| 1 | 12695 | |
| 8 | 10415 | |
| 7 | 2280 | 4.5% |
arrival_month
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.4315872 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 714.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 5 |
| median | 8 |
| Q3 | 10 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.0842425 |
|---|---|
| Coefficient of variation (CV) | 0.41501801 |
| Kurtosis | -0.96157185 |
| Mean | 7.4315872 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.34099091 |
| Sum | 94344 |
| Variance | 9.5125519 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 10 | 1879 | |
| 9 | 1623 | |
| 8 | 1282 | |
| 6 | 1107 | |
| 12 | 1085 | |
| 11 | 1055 | |
| 4 | 1015 | |
| 7 | 968 | |
| 5 | 917 | |
| 3 | 821 | |
| Other values (2) | 943 |
| Value | Count | Frequency (%) |
| 1 | 346 | 2.7% |
| 2 | 597 | 4.7% |
| 3 | 821 | |
| 4 | 1015 | |
| 5 | 917 | |
| 6 | 1107 | |
| 7 | 968 | |
| 8 | 1282 | |
| 9 | 1623 | |
| 10 | 1879 |
| Value | Count | Frequency (%) |
| 12 | 1085 | |
| 11 | 1055 | |
| 10 | 1879 | |
| 9 | 1623 | |
| 8 | 1282 | |
| 7 | 968 | |
| 6 | 1107 | |
| 5 | 917 | |
| 4 | 1015 | |
| 3 | 821 |
arrival_date
Real number (ℝ)
| Distinct | 31 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.743127 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 714.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 30 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.7659164 |
|---|---|
| Coefficient of variation (CV) | 0.55680909 |
| Kurtosis | -1.1698083 |
| Mean | 15.743127 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.012229463 |
| Sum | 199859 |
| Variance | 76.84129 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=31)
| Value | Count | Frequency (%) |
| 13 | 499 | 3.9% |
| 17 | 466 | 3.7% |
| 2 | 457 | 3.6% |
| 4 | 456 | 3.6% |
| 19 | 456 | 3.6% |
| 16 | 450 | 3.5% |
| 30 | 438 | 3.5% |
| 20 | 429 | 3.4% |
| 6 | 428 | 3.4% |
| 25 | 427 | 3.4% |
| Other values (21) | 8189 |
| Value | Count | Frequency (%) |
| 1 | 383 | |
| 2 | 457 | |
| 3 | 386 | |
| 4 | 456 | |
| 5 | 391 | |
| 6 | 428 | |
| 7 | 378 | |
| 8 | 405 | |
| 9 | 398 | |
| 10 | 409 |
| Value | Count | Frequency (%) |
| 31 | 214 | |
| 30 | 438 | |
| 29 | 407 | |
| 28 | 417 | |
| 27 | 393 | |
| 26 | 416 | |
| 25 | 427 | |
| 24 | 389 | |
| 23 | 358 | |
| 22 | 370 |
market_segment_type
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 714.4 KiB |
| 1 | |
|---|---|
| 0 | |
| 2 | 693 |
| 4 | 137 |
| 3 | 35 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 12695 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 1 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 8117 | |
| 0 | 3713 | |
| 2 | 693 | 5.5% |
| 4 | 137 | 1.1% |
| 3 | 35 | 0.3% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 8117 | |
| 0 | 3713 | |
| 2 | 693 | 5.5% |
| 4 | 137 | 1.1% |
| 3 | 35 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 8117 | |
| 0 | 3713 | |
| 2 | 693 | 5.5% |
| 4 | 137 | 1.1% |
| 3 | 35 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 12695 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 8117 | |
| 0 | 3713 | |
| 2 | 693 | 5.5% |
| 4 | 137 | 1.1% |
| 3 | 35 | 0.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 12695 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 8117 | |
| 0 | 3713 | |
| 2 | 693 | 5.5% |
| 4 | 137 | 1.1% |
| 3 | 35 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 12695 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 8117 | |
| 0 | 3713 | |
| 2 | 693 | 5.5% |
| 4 | 137 | 1.1% |
| 3 | 35 | 0.3% |
repeated_guest
Categorical
HIGH CORRELATION IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 714.4 KiB |
| 0 | |
|---|---|
| 1 | 320 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 12695 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 12375 | |
| 1 | 320 | 2.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 12375 | |
| 1 | 320 | 2.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 12375 | |
| 1 | 320 | 2.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 12695 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 12375 | |
| 1 | 320 | 2.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 12695 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 12375 | |
| 1 | 320 | 2.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 12695 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 12375 | |
| 1 | 320 | 2.5% |
no_of_previous_cancellations
Real number (ℝ)
SKEWED ZEROS
| Distinct | 9 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.022371012 |
| Minimum | 0 |
|---|---|
| Maximum | 13 |
| Zeros | 12587 |
| Zeros (%) | 99.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 714.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 13 |
| Range | 13 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.35543083 |
|---|---|
| Coefficient of variation (CV) | 15.888008 |
| Kurtosis | 740.84076 |
| Mean | 0.022371012 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 25.124305 |
| Sum | 284 |
| Variance | 0.12633107 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=9)
| Value | Count | Frequency (%) |
| 0 | 12587 | |
| 1 | 56 | 0.4% |
| 3 | 18 | 0.1% |
| 2 | 16 | 0.1% |
| 11 | 8 | 0.1% |
| 4 | 5 | < 0.1% |
| 5 | 3 | < 0.1% |
| 6 | 1 | < 0.1% |
| 13 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 12587 | |
| 1 | 56 | 0.4% |
| 2 | 16 | 0.1% |
| 3 | 18 | 0.1% |
| 4 | 5 | < 0.1% |
| 5 | 3 | < 0.1% |
| 6 | 1 | < 0.1% |
| 11 | 8 | 0.1% |
| 13 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 13 | 1 | < 0.1% |
| 11 | 8 | 0.1% |
| 6 | 1 | < 0.1% |
| 5 | 3 | < 0.1% |
| 4 | 5 | < 0.1% |
| 3 | 18 | 0.1% |
| 2 | 16 | 0.1% |
| 1 | 56 | 0.4% |
| 0 | 12587 |
no_of_previous_bookings_not_canceled
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 40 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.15872391 |
| Minimum | 0 |
|---|---|
| Maximum | 58 |
| Zeros | 12409 |
| Zeros (%) | 97.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 714.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 58 |
| Range | 58 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.7886424 |
|---|---|
| Coefficient of variation (CV) | 11.268891 |
| Kurtosis | 433.41322 |
| Mean | 0.15872391 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 18.801114 |
| Sum | 2015 |
| Variance | 3.1992415 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=40)
| Value | Count | Frequency (%) |
| 0 | 12409 | |
| 1 | 76 | 0.6% |
| 2 | 39 | 0.3% |
| 3 | 30 | 0.2% |
| 4 | 24 | 0.2% |
| 5 | 17 | 0.1% |
| 8 | 14 | 0.1% |
| 6 | 11 | 0.1% |
| 7 | 10 | 0.1% |
| 10 | 7 | 0.1% |
| Other values (30) | 58 | 0.5% |
| Value | Count | Frequency (%) |
| 0 | 12409 | |
| 1 | 76 | 0.6% |
| 2 | 39 | 0.3% |
| 3 | 30 | 0.2% |
| 4 | 24 | 0.2% |
| 5 | 17 | 0.1% |
| 6 | 11 | 0.1% |
| 7 | 10 | 0.1% |
| 8 | 14 | 0.1% |
| 9 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 58 | 1 | |
| 51 | 1 | |
| 50 | 1 | |
| 48 | 1 | |
| 47 | 1 | |
| 45 | 1 | |
| 44 | 1 | |
| 41 | 1 | |
| 37 | 1 | |
| 36 | 1 |
avg_price_per_room
Real number (ℝ)
| Distinct | 2203 |
|---|---|
| Distinct (%) | 17.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 103.51919 |
| Minimum | 0 |
|---|---|
| Maximum | 375.5 |
| Zeros | 193 |
| Zeros (%) | 1.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 714.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 61 |
| Q1 | 80.1 |
| median | 99.45 |
| Q3 | 120.6 |
| 95-th percentile | 166 |
| Maximum | 375.5 |
| Range | 375.5 |
| Interquartile range (IQR) | 40.5 |
Descriptive statistics
| Standard deviation | 35.370949 |
|---|---|
| Coefficient of variation (CV) | 0.34168496 |
| Kurtosis | 2.3580546 |
| Mean | 103.51919 |
| Median Absolute Deviation (MAD) | 20.4 |
| Skewness | 0.60462227 |
| Sum | 1314176.1 |
| Variance | 1251.1041 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 75 | 321 | 2.5% |
| 65 | 312 | 2.5% |
| 90 | 250 | 2.0% |
| 115 | 242 | 1.9% |
| 95 | 236 | 1.9% |
| 120 | 221 | 1.7% |
| 110 | 210 | 1.7% |
| 0 | 193 | 1.5% |
| 100 | 192 | 1.5% |
| 85 | 167 | 1.3% |
| Other values (2193) | 10351 |
| Value | Count | Frequency (%) |
| 0 | 193 | |
| 1 | 3 | < 0.1% |
| 2 | 3 | < 0.1% |
| 3 | 1 | < 0.1% |
| 6 | 10 | 0.1% |
| 6.5 | 1 | < 0.1% |
| 6.67 | 1 | < 0.1% |
| 9 | 2 | < 0.1% |
| 12 | 7 | 0.1% |
| 15 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 375.5 | 1 | |
| 314.1 | 1 | |
| 300 | 2 | |
| 296 | 1 | |
| 279.2 | 1 | |
| 278.9 | 1 | |
| 265.44 | 1 | |
| 264.1 | 1 | |
| 263.55 | 1 | |
| 260.9 | 1 |
no_of_special_requests
Real number (ℝ)
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.62528555 |
| Minimum | 0 |
|---|---|
| Maximum | 5 |
| Zeros | 6897 |
| Zeros (%) | 54.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 714.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.79090482 |
|---|---|
| Coefficient of variation (CV) | 1.2648698 |
| Kurtosis | 0.86576038 |
| Mean | 0.62528555 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.1382346 |
| Sum | 7938 |
| Variance | 0.62553043 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 0 | 6897 | |
| 1 | 3962 | |
| 2 | 1568 | 12.4% |
| 3 | 235 | 1.9% |
| 4 | 30 | 0.2% |
| 5 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 6897 | |
| 1 | 3962 | |
| 2 | 1568 | 12.4% |
| 3 | 235 | 1.9% |
| 4 | 30 | 0.2% |
| 5 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 5 | 3 | < 0.1% |
| 4 | 30 | 0.2% |
| 3 | 235 | 1.9% |
| 2 | 1568 | 12.4% |
| 1 | 3962 | |
| 0 | 6897 |
booking_status
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 714.4 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 12695 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 1 |
| 3rd row | 0 |
| 4th row | 1 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 8555 | |
| 1 | 4140 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 8555 | |
| 1 | 4140 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 8555 | |
| 1 | 4140 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 12695 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 8555 | |
| 1 | 4140 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 12695 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 8555 | |
| 1 | 4140 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 12695 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 8555 | |
| 1 | 4140 |
| no_of_weekend_nights | no_of_week_nights | room_type_reserved | lead_time | arrival_month | arrival_date | no_of_previous_cancellations | no_of_previous_bookings_not_canceled | avg_price_per_room | no_of_special_requests | no_of_adults | no_of_children | type_of_meal_plan | required_car_parking_space | arrival_year | market_segment_type | repeated_guest | booking_status | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| no_of_weekend_nights | 1.000 | 0.017 | 0.074 | 0.106 | -0.014 | 0.022 | -0.023 | -0.057 | -0.028 | 0.067 | 0.067 | 0.028 | 0.043 | 0.011 | 0.068 | 0.116 | 0.056 | 0.080 |
| no_of_week_nights | 0.017 | 1.000 | 0.112 | 0.240 | 0.062 | -0.012 | -0.041 | -0.125 | 0.032 | 0.050 | 0.078 | 0.022 | 0.068 | 0.063 | 0.036 | 0.122 | 0.122 | 0.105 |
| room_type_reserved | 0.074 | 0.112 | 1.000 | -0.049 | -0.007 | 0.039 | -0.021 | -0.024 | 0.374 | 0.141 | 0.306 | 0.473 | 0.159 | 0.040 | 0.099 | 0.175 | 0.072 | 0.048 |
| lead_time | 0.106 | 0.240 | -0.049 | 1.000 | 0.081 | -0.000 | -0.096 | -0.194 | -0.028 | -0.090 | 0.103 | 0.037 | 0.173 | 0.078 | 0.150 | 0.177 | 0.163 | 0.440 |
| arrival_month | -0.014 | 0.062 | -0.007 | 0.081 | 1.000 | -0.036 | 0.012 | 0.001 | 0.013 | 0.080 | 0.092 | 0.068 | 0.097 | 0.048 | 0.393 | 0.101 | 0.063 | 0.180 |
| arrival_date | 0.022 | -0.012 | 0.039 | -0.000 | -0.036 | 1.000 | -0.010 | -0.001 | 0.002 | 0.026 | 0.042 | 0.026 | 0.070 | 0.019 | 0.081 | 0.045 | 0.029 | 0.027 |
| no_of_previous_cancellations | -0.023 | -0.041 | -0.021 | -0.096 | 0.012 | -0.010 | 1.000 | 0.419 | -0.098 | -0.030 | 0.037 | 0.000 | 0.000 | 0.042 | 0.014 | 0.117 | 0.398 | 0.038 |
| no_of_previous_bookings_not_canceled | -0.057 | -0.125 | -0.024 | -0.194 | 0.001 | -0.001 | 0.419 | 1.000 | -0.177 | -0.001 | 0.065 | 0.000 | 0.000 | 0.091 | 0.015 | 0.162 | 0.553 | 0.054 |
| avg_price_per_room | -0.028 | 0.032 | 0.374 | -0.028 | 0.013 | 0.002 | -0.098 | -0.177 | 1.000 | 0.200 | 0.195 | 0.316 | 0.119 | 0.076 | 0.204 | 0.407 | 0.228 | 0.171 |
| no_of_special_requests | 0.067 | 0.050 | 0.141 | -0.090 | 0.080 | 0.026 | -0.030 | -0.001 | 0.200 | 1.000 | 0.116 | 0.102 | 0.068 | 0.091 | 0.094 | 0.207 | 0.030 | 0.254 |
| no_of_adults | 0.067 | 0.078 | 0.306 | 0.103 | 0.092 | 0.042 | 0.037 | 0.065 | 0.195 | 0.116 | 1.000 | 0.214 | 0.088 | 0.025 | 0.104 | 0.197 | 0.234 | 0.110 |
| no_of_children | 0.028 | 0.022 | 0.473 | 0.037 | 0.068 | 0.026 | 0.000 | 0.000 | 0.316 | 0.102 | 0.214 | 1.000 | 0.050 | 0.026 | 0.063 | 0.099 | 0.034 | 0.042 |
| type_of_meal_plan | 0.043 | 0.068 | 0.159 | 0.173 | 0.097 | 0.070 | 0.000 | 0.000 | 0.119 | 0.068 | 0.088 | 0.050 | 1.000 | 0.036 | 0.185 | 0.235 | 0.072 | 0.087 |
| required_car_parking_space | 0.011 | 0.063 | 0.040 | 0.078 | 0.048 | 0.019 | 0.042 | 0.091 | 0.076 | 0.091 | 0.025 | 0.026 | 0.036 | 1.000 | 0.000 | 0.122 | 0.116 | 0.089 |
| arrival_year | 0.068 | 0.036 | 0.099 | 0.150 | 0.393 | 0.081 | 0.014 | 0.015 | 0.204 | 0.094 | 0.104 | 0.063 | 0.185 | 0.000 | 1.000 | 0.182 | 0.015 | 0.178 |
| market_segment_type | 0.116 | 0.122 | 0.175 | 0.177 | 0.101 | 0.045 | 0.117 | 0.162 | 0.407 | 0.207 | 0.197 | 0.099 | 0.235 | 0.122 | 0.182 | 1.000 | 0.475 | 0.150 |
| repeated_guest | 0.056 | 0.122 | 0.072 | 0.163 | 0.063 | 0.029 | 0.398 | 0.553 | 0.228 | 0.030 | 0.234 | 0.034 | 0.072 | 0.116 | 0.015 | 0.475 | 1.000 | 0.107 |
| booking_status | 0.080 | 0.105 | 0.048 | 0.440 | 0.180 | 0.027 | 0.038 | 0.054 | 0.171 | 0.254 | 0.110 | 0.042 | 0.087 | 0.089 | 0.178 | 0.150 | 0.107 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| no_of_adults | no_of_children | no_of_weekend_nights | no_of_week_nights | type_of_meal_plan | required_car_parking_space | room_type_reserved | lead_time | arrival_year | arrival_month | arrival_date | market_segment_type | repeated_guest | no_of_previous_cancellations | no_of_previous_bookings_not_canceled | avg_price_per_room | no_of_special_requests | booking_status | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15946 | 2 | 0 | 2 | 3 | 0 | 0 | 1 | 45 | 2018 | 11 | 24 | 1 | 0 | 0 | 0 | 96.90 | 2 | 0 |
| 12132 | 2 | 0 | 1 | 2 | 0 | 0 | 0 | 273 | 2018 | 5 | 13 | 0 | 0 | 0 | 0 | 95.00 | 0 | 1 |
| 217 | 2 | 0 | 0 | 2 | 0 | 0 | 0 | 68 | 2017 | 9 | 29 | 0 | 0 | 0 | 0 | 65.00 | 0 | 0 |
| 3858 | 2 | 0 | 0 | 3 | 0 | 0 | 1 | 41 | 2018 | 2 | 4 | 1 | 0 | 0 | 0 | 82.45 | 0 | 1 |
| 17908 | 2 | 0 | 1 | 1 | 0 | 0 | 0 | 159 | 2018 | 4 | 9 | 0 | 0 | 0 | 0 | 70.00 | 1 | 0 |
| 12018 | 2 | 0 | 2 | 2 | 1 | 0 | 0 | 110 | 2018 | 6 | 17 | 1 | 0 | 0 | 0 | 109.65 | 1 | 0 |
| 2477 | 2 | 0 | 1 | 3 | 0 | 0 | 0 | 285 | 2018 | 10 | 3 | 0 | 0 | 0 | 0 | 100.00 | 0 | 1 |
| 1824 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 2017 | 9 | 2 | 2 | 0 | 0 | 0 | 65.00 | 0 | 0 |
| 13297 | 2 | 0 | 4 | 10 | 0 | 0 | 1 | 152 | 2018 | 10 | 24 | 0 | 0 | 0 | 0 | 80.39 | 0 | 1 |
| 12622 | 2 | 1 | 2 | 1 | 0 | 1 | 1 | 131 | 2018 | 7 | 2 | 1 | 0 | 0 | 0 | 121.50 | 1 | 0 |
| no_of_adults | no_of_children | no_of_weekend_nights | no_of_week_nights | type_of_meal_plan | required_car_parking_space | room_type_reserved | lead_time | arrival_year | arrival_month | arrival_date | market_segment_type | repeated_guest | no_of_previous_cancellations | no_of_previous_bookings_not_canceled | avg_price_per_room | no_of_special_requests | booking_status | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3481 | 2 | 0 | 1 | 3 | 0 | 0 | 0 | 75 | 2018 | 3 | 17 | 1 | 0 | 0 | 0 | 80.00 | 0 | 1 |
| 111 | 1 | 1 | 0 | 1 | 2 | 0 | 0 | 29 | 2018 | 12 | 17 | 1 | 0 | 0 | 0 | 130.00 | 0 | 0 |
| 942 | 1 | 0 | 2 | 0 | 0 | 0 | 0 | 2 | 2017 | 9 | 20 | 0 | 0 | 0 | 0 | 77.00 | 0 | 0 |
| 5664 | 2 | 0 | 1 | 2 | 0 | 0 | 3 | 30 | 2018 | 5 | 6 | 1 | 0 | 0 | 0 | 198.90 | 2 | 0 |
| 96 | 2 | 0 | 0 | 3 | 0 | 0 | 0 | 33 | 2018 | 9 | 28 | 0 | 0 | 0 | 0 | 85.50 | 0 | 0 |
| 13435 | 2 | 0 | 1 | 2 | 0 | 0 | 4 | 94 | 2018 | 3 | 25 | 1 | 0 | 0 | 0 | 95.25 | 0 | 0 |
| 7763 | 2 | 0 | 0 | 4 | 0 | 0 | 1 | 33 | 2018 | 2 | 23 | 1 | 0 | 0 | 0 | 61.60 | 1 | 0 |
| 15377 | 2 | 0 | 1 | 4 | 0 | 0 | 1 | 34 | 2018 | 4 | 4 | 1 | 0 | 0 | 0 | 131.40 | 0 | 1 |
| 17730 | 2 | 0 | 0 | 2 | 0 | 0 | 0 | 12 | 2017 | 12 | 16 | 0 | 0 | 0 | 0 | 58.00 | 0 | 0 |
| 15725 | 1 | 0 | 1 | 2 | 0 | 0 | 0 | 0 | 2017 | 8 | 3 | 2 | 0 | 0 | 0 | 65.00 | 0 | 0 |
Most frequently occurring
| no_of_adults | no_of_children | no_of_weekend_nights | no_of_week_nights | type_of_meal_plan | required_car_parking_space | room_type_reserved | lead_time | arrival_year | arrival_month | arrival_date | market_segment_type | repeated_guest | no_of_previous_cancellations | no_of_previous_bookings_not_canceled | avg_price_per_room | no_of_special_requests | booking_status | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 84 | 1 | 0 | 0 | 2 | 0 | 0 | 0 | 192 | 2018 | 6 | 24 | 0 | 0 | 0 | 0 | 95.0 | 0 | 0 | 34 |
| 113 | 1 | 0 | 0 | 3 | 0 | 0 | 0 | 71 | 2018 | 6 | 14 | 0 | 0 | 0 | 0 | 120.0 | 0 | 0 | 34 |
| 404 | 2 | 0 | 0 | 3 | 0 | 0 | 0 | 37 | 2018 | 10 | 13 | 0 | 0 | 0 | 0 | 105.0 | 0 | 0 | 29 |
| 78 | 1 | 0 | 0 | 2 | 0 | 0 | 0 | 164 | 2017 | 10 | 2 | 0 | 0 | 0 | 0 | 100.0 | 0 | 0 | 26 |
| 619 | 2 | 0 | 1 | 2 | 0 | 0 | 0 | 305 | 2018 | 11 | 4 | 0 | 0 | 0 | 0 | 89.0 | 0 | 1 | 26 |
| 118 | 1 | 0 | 0 | 3 | 0 | 0 | 0 | 166 | 2018 | 11 | 1 | 0 | 0 | 0 | 0 | 110.0 | 0 | 1 | 24 |
| 447 | 2 | 0 | 0 | 3 | 0 | 0 | 0 | 304 | 2018 | 11 | 3 | 0 | 0 | 0 | 0 | 89.0 | 0 | 1 | 24 |
| 250 | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 56 | 2018 | 6 | 8 | 0 | 0 | 0 | 0 | 120.0 | 0 | 0 | 23 |
| 282 | 2 | 0 | 0 | 1 | 2 | 0 | 0 | 55 | 2018 | 4 | 6 | 0 | 0 | 0 | 0 | 104.0 | 0 | 0 | 22 |
| 391 | 2 | 0 | 0 | 2 | 2 | 0 | 0 | 377 | 2018 | 10 | 14 | 0 | 0 | 0 | 0 | 115.0 | 1 | 1 | 22 |